<?php

//############################################
//Now import the settings
include_once("settings.php");

//############################################
//Connect to the db
mysql_connect($db_host,$MySqlUN,$MySqlPW);
@mysql_select_db($database) or die( "Unable to select databases");

//Define the temp table
$query = "create table carttemp (
carttemp_hidden INT(10) NOT NULL AUTO_INCREMENT,
carttemp_sess CHAR(50) NOT NULL,
carttemp_prodnum CHAR(5) NOT NULL,
carttemp_quan INT(3) NOT NULL,
PRIMARY KEY(carttemp_hidden),
KEY(carttemp_sess))";

$temp = mysql_query($query) or die(mysql_error());
echo "Temporary cart table created successfully";
?>